CodIsirComment

EntityType | Independent
Logical Entity Name | CodIsirComment
Default Table Name | FaSysComments
Logical Only | NO
Owner | dbo
Definition |
Note |

CodIsirComment Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
AwardYear |  | CHAR(7) | YES |
Type |  | CHAR(10) | YES |
Code |  | CHAR(3) | YES |
Comment |  | VARCHAR(1000) | YES |
LineCount |  | INTEGER | YES |
MessageType |  | CHAR(1) | YES |
RejectCode |  | VARCHAR(2) | YES |
IsCCode |  | BIT | NO |
IsPellSeogIneligble |  | BIT | NO |
IsTitle4Ineligble |  | BIT | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
ResourceKey |  | NVARCHAR(128) | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |

CodIsirComment Keys

Key Name | Key Type | Keys
FaSysComments_Code_Type_AwardYear_FaSysCommentsID_U_N_IDX | Alternate Key | Code, Type, AwardYear, Id
FaSysComments_Type_N_N_IDX | Inversion Entry | Type
FaSysComments_AwardYear_N_N_IDX | Inversion Entry | AwardYear
FaSysComments_FaSysCommentsID_U_C_IDX | PrimaryKey | Id
FaSysComments_Type_AwardYear_N_N_IDX | Inversion Entry | Type, AwardYear

CodIsirComment Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
FaaProcessExceptionTypeTemplate | Non-Identifying | Zero or One to Zero or More |  |  |  | ResourceKey | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

CodIsirComment Check Constraints

Check Constraint Name | CheckConstraint
Chk_FaSysComments_AwardYear_RejectCode | ([AwardYear] = '2003-04' and ([RejectCode] = 'DE' or ([RejectCode] = '1' or ([RejectCode] = 'P' or ([RejectCode] = '16' or ([RejectCode] = 'W' or ([RejectCode] = '9' or ([RejectCode] = '17' or ([RejectCode] = '8' or ([RejectCode] = '18' or ([RejectCode] = '10' or ([RejectCode] = 'R' or ([RejectCode] = 'B' or ([RejectCode] = '11' or ([RejectCode] = '19' or ([RejectCode] = '2' or ([RejectCode] = 'A' or ([RejectCode] = 'D' or ([RejectCode] = '12' or ([RejectCode] = '5' or ([RejectCode] = '13' or ([RejectCode] = 'C' or ([RejectCode] = '14' or ([RejectCode] = 'N' or ([RejectCode] = 'E' or [RejectCode] = '15')))))))))))))))))))))))) or [AwardYear] = '2003-04' and [RejectCode] is null or [AwardYear] <> '2003-04')

CodIsirComment Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.CodIsirComment | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaSysComments | NO |  |  |

CodIsirComment Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

CodIsirComment Data Movement Rules

Name | Type | Rule Text/Value